SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003495s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578516 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578516 [ RunTime:0.002508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410258,439183,959342,711826,218127,540984,1008762,496398,79705,55071,87410,509749,226332,629799,957494,641179,457545,787337,89442,728031,908443,1042326,595702,647547,228931,1004125,580769,937511,896602,679482,800038,561387,204249,17367,1044111,565539,344115,455227,349799,557575,33195,439181,80700,301722,734228,498188,25359,269313,994442,567451,799544,136781,897169,823770,484277,988072,611837,751208,82585,911497) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003880s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]