SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001276s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006438 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006438 [ RunTime:0.001673s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (60109,461988,677235,399333,887777,791104,317187,647701,560542,583666,364320,478960,255470,645013,979737,823428,32230,919070,705757,728105,390014,252958,1047567,385742,889120,659678,725691,347030,884255,632917,954462,685079,291220,353158,332913,717307,552965,561764,983537,626982,457781,897023,2103,917273,15433,796750,8767,662992,322610,445375,334003,1038429,677050,129325,1047147,1019089,904466,722447,598765,784574) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001002s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000527s ]