SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046712 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046712 [ RunTime:0.001677s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (926825,260626,1045199,457608,534888,103611,918209,595538,558016,721816,818159,550102,524347,225668,399281,803088,599061,29319,931955,512672,69942,255758,206886,996987,235751,590722,167865,659849,563023,192396,648384,289734,834871,1009565,20293,231280,387892,1029044,933648,287416,162639,669943,231563,829443,545697,577057,695660,817157,1002889,728606,468417,114025,61150,974093,41089,221993,793426,501978,431718,423876) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046712 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000452s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046712 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]