SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529093 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529093 [ RunTime:0.002235s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1022830,103180,706463,450854,487591,888485,94642,226612,628280,1017754,1032959,850036,492673,822556,819558,708900,697194,661529,379637,389720,241910,554212,382733,120927,374185,367255,840220,317420,570160,831378,98596,119931,884891,526697,639144,391423,966147,361987,940392,257028,987102,232871,835959,13885,491118,541070,492214,159206,231913,847678,355068,83100,638624,401328,290395,440946,309457,341,53926,123966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000585s ]