SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.006668s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008694 LIMIT 1 [ RunTime:0.002402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008694 [ RunTime:0.004606s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212433,591334,812306,196693,359783,573790,688553,379790,186233,472786,55768,368216,746401,249384,89301,209549,755987,802431,450136,130355,682325,814848,399729,711612,825174,406352,386230,221780,55801,192511,150288,637350,1025339,519658,752006,800244,1030602,741382,274591,979457,477171,973038,797481,557234,760208,298907,587532,256449,495292,220287,13547,182515,408053,617040,917471,141765,772504,276059,652880,896020) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.024680s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008694 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008694 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002571s ]