SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001252s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570825 LIMIT 1 [ RunTime:0.000444s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570825 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (561271,603775,153575,479684,420720,694480,748529,37143,610326,518879,411175,632334,496425,1044554,7459,577303,94723,340199,600890,171624,890924,580867,694383,161785,907976,241667,754861,848991,605557,559713,10855,882200,35718,533177,494121,966304,758842,625632,899091,552579,462205,200931,220113,788052,619741,586488,972030,104152,619564,31066,720299,409565,474904,974278,690468,627027,93297,960800,684567,87948) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001894s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]