SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001128s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 294412 LIMIT 1 [ RunTime:0.000300s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 294412 [ RunTime:0.002010s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (80780,907160,211722,536114,328534,529973,815318,166895,413011,199507,819323,619527,437180,604171,634728,605834,256940,823987,320675,633386,306049,814545,192613,553864,177228,981060,618334,156792,350505,1025430,933757,99179,668088,302684,525722,970272,1040023,77735,990352,389491,23107,153425,189888,586467,803155,463608,491926,144697,373256,286545,388750,507298,555493,725784,626792,661626,277113,385468,861327,929056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001027s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 294412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 294412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000465s ]