SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 943895 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 943895 [ RunTime:0.003765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (802932,148243,120516,446070,125780,567303,732936,830321,557952,256095,279757,412425,489940,857426,674930,859525,79100,201581,445222,385079,232228,54484,346374,221388,617627,675540,469713,873857,830140,907600,344574,468023,338196,30261,284092,720299,1008981,39612,93106,580693,195898,415349,313276,489719,768300,695012,554657,775238,961719,669398,1020593,790049,905445,109418,216411,340581,977861,568501,625838,308153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 943895 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 943895 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000437s ]