SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002043s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 284070 LIMIT 1 [ RunTime:0.000579s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 284070 [ RunTime:0.001728s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (637045,838895,749892,1035564,284094,263399,945123,536192,573790,438143,345208,887087,478033,763585,453880,928637,998095,1036013,55760,876192,169479,997602,697065,406568,670104,128962,772987,819188,957706,496754,677623,671177,509903,743441,688900,1048761,418789,958743,995328,528277,349989,608650,346251,723432,783085,816764,499080,909975,765943,463448,654815,735415,461633,601356,642155,148182,39441,854011,243972,340905) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001045s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 284070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 284070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]