SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 981037 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 981037 [ RunTime:0.001454s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (788314,49675,408653,744510,149759,879221,790326,941433,50012,549325,183030,208694,952844,372983,25362,256553,777510,931644,443252,689814,807753,729730,961450,35017,310216,576656,343024,809928,125782,8700,582426,774740,691763,322270,663604,259191,236695,111543,588193,838782,758960,952800,943927,146980,711512,31319,423376,16604,111,314635,392004,371059,953540,608834,953314,879630,807167,1048793,855902,730145) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000955s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 981037 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 981037 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000413s ]