SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 52584 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 52584 [ RunTime:0.002668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (664088,253575,332626,283027,608724,17270,461350,566729,140204,787385,555233,612966,212619,1004249,805703,251928,658315,497726,848796,208351,709469,198571,831938,288854,1027175,656739,469547,401454,229668,190621,887934,634484,410174,133392,609610,603058,317175,773667,901776,76138,908421,1044121,354371,592250,840985,508638,300355,156698,793333,1005602,84356,991910,716317,763191,895687,119857,38827,552404,211741,780155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 52584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000617s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 52584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000555s ]