SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001289s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406815 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406815 [ RunTime:0.001631s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269435,426438,497600,247760,1039985,958887,897750,487350,729886,403336,774814,936435,72606,789576,992256,807111,991535,157691,48807,671148,287251,848613,506784,552577,458437,945485,469047,155810,100043,549920,310708,525540,37261,694921,423350,22924,748090,743241,441442,581126,519139,282557,718571,881989,549205,927671,263341,646902,1013001,922754,69648,48285,441500,161445,257237,456286,854333,81135,355477,1033019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000502s ]