SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10152 LIMIT 1 [ RunTime:0.000577s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10152 [ RunTime:0.003740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (187546,526397,263905,148475,807538,665575,798501,904298,270433,932176,401266,498390,504779,191882,201384,1025049,95251,671017,1026849,372081,506766,200210,908383,356797,741243,850867,644850,603414,143318,1017107,35617,521642,883787,44941,318135,279721,575134,793407,512374,71613,959915,649423,695595,413049,634382,880207,248970,278316,687458,114780,15111,257315,349956,51505,627587,59327,65712,826119,544783,376194) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001239s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000490s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]