SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009318 LIMIT 1 [ RunTime:0.001951s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009318 [ RunTime:0.007282s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963088,578709,103263,179011,428959,944107,90599,66187,331566,679013,238453,966153,967535,837115,786070,421086,299460,1009613,360863,710901,665855,189126,414115,902973,69975,794695,484045,615132,796452,58326,923030,845385,714540,413913,80857,25698,689226,970700,1002240,978059,250098,205270,728812,1009242,682872,322660,1013128,25107,304644,961182,836017,83454,749737,169351,848407,924191,954694,991453,669142,399323) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001511s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009318 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009318 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]