SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001274s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 565343 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 565343 [ RunTime:0.001417s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395976,471728,72225,178954,26322,924538,907313,285205,835777,881373,727551,327288,97596,59728,209517,862687,113520,90328,67606,208576,758988,39210,801994,895680,255571,802344,991316,497152,549202,600343,52161,789933,172222,414255,595402,320091,35658,844596,337054,918511,603023,72155,1014093,155190,503574,295067,234674,435415,1007542,167443,899396,660140,339415,927682,981910,616962,664966,973641,913941,272727) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 565343 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 565343 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001024s ]