SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002367s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047683 LIMIT 1 [ RunTime:0.001224s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047683 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (698638,690500,341718,6211,384481,991263,456781,1008035,240328,211286,290816,253629,191580,306101,696607,981461,720805,851722,523704,131551,915378,611124,64457,462457,580276,98883,914656,368626,523554,209217,655615,1028497,632872,996296,965192,326684,647100,39823,1000164,43925,411210,228919,861548,378470,1024276,723028,981738,434198,70760,977660,872952,190829,1002663,853549,1047622,912760,162198,400847,59843,921920) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047683 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047683 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000540s ]