SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001247 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001247 [ RunTime:0.001803s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036754,229071,76569,916532,540637,460662,158666,1023408,641680,167921,279495,763844,739557,147375,456503,858170,50206,667176,493179,601615,143075,974595,171418,323276,644239,525646,802577,558119,1012130,92344,229732,1003941,76613,440158,73427,65958,862698,102793,202088,276267,198419,224585,861669,131001,162085,115663,721289,600203,381456,237470,437693,152319,934559,21338,411144,958494,673691,495892,588143,382548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001656s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001247 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001247 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]