SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 742104 LIMIT 1 [ RunTime:0.001038s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 742104 [ RunTime:0.001777s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728613,102478,684572,314538,55730,412206,556606,388405,385813,868972,686016,298937,314986,593563,432175,498468,847455,369134,756143,651481,741434,419794,515514,827902,295787,1039510,551845,467409,978464,317000,422092,744779,320004,1002779,346853,107566,865424,176077,215913,40168,1032352,460453,680275,379976,192372,391975,219730,585057,403810,206248,432036,256575,181719,31581,694541,381951,420173,1003673,79457,748301) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.021583s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 742104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 742104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001313s ]