SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416090 LIMIT 1 [ RunTime:0.000304s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416090 [ RunTime:0.001401s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (581985,791633,568890,93889,544591,518405,958237,896577,1031420,59720,648304,601305,105168,862238,434130,808194,778001,374213,23102,1024879,665545,496200,396923,974858,392707,851663,723024,599358,729564,705788,828396,855638,1010328,224722,1032889,197191,800733,526990,427200,694290,488514,611964,671867,193233,74442,712589,130260,335644,700890,162574,239381,22375,607787,822228,170294,477036,255561,237715,460124,202126) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416090 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416090 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000463s ]