SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 438563 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 438563 [ RunTime:0.001886s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (878788,21773,842759,259707,117498,16892,494810,922422,884838,482078,239252,558790,809037,401009,401242,273566,736603,702159,71271,805209,301166,1035582,758765,657568,131171,339741,1006743,376312,553545,360901,1007424,175194,563440,906995,870759,915678,857462,284247,874894,955270,1037471,753780,559476,97444,967584,22960,1023498,97273,151928,803576,161533,660698,694239,977326,590334,466558,633701,353268,1043287,150755) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 438563 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 438563 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000474s ]