SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402978 LIMIT 1 [ RunTime:0.002085s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402978 [ RunTime:0.002858s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (138370,760768,88407,1017925,543822,951774,176122,776913,221625,994116,26754,579325,945897,340133,504901,561237,243453,946581,491684,1037499,409940,555677,139258,50696,433754,502639,267756,519802,282879,645865,265137,480577,217817,452687,202389,886320,36856,933959,281607,384101,787468,177885,17787,763519,156828,242006,908335,565016,970934,644538,674759,697659,373069,898456,890660,351685,479359,817230,626354,159877) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001310s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402978 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402978 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]