SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 54128 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 54128 [ RunTime:0.002336s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (169126,507423,947329,940545,395066,349318,305523,1006995,131018,799485,524635,399136,161788,873638,99828,145800,595750,178586,281687,556092,936432,537620,129185,802393,665504,863730,123722,49095,550069,988993,2382,630576,88512,677358,782734,116751,134186,856608,826953,834215,542987,63928,963665,414529,460183,1104,12345,205730,541792,394647,914380,262547,43931,628672,77528,71090,916125,551249,41660,72053) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 54128 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000334s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 54128 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000588s ]