SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507674 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507674 [ RunTime:0.002145s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (428742,332607,645538,96315,102864,510864,477178,460085,299536,984368,472219,709024,1000878,1010885,2100,945901,468526,323581,709255,842740,927959,1012768,788348,26073,205154,473101,503965,733950,771989,545444,771056,34083,685906,744476,142611,628175,361954,957206,582025,270353,453027,898360,925747,744967,147493,462458,258614,302114,943955,715869,488496,910356,564037,646407,1031576,774788,892622,220076,85671,247703) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]