SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 310641 LIMIT 1 [ RunTime:0.001288s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 310641 [ RunTime:0.001821s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (657244,321058,185955,336808,418536,665241,970466,406546,1040727,530718,386191,467191,667217,441231,227017,120647,927133,816262,966506,446556,1033049,96343,798596,978057,503368,513100,200297,675301,312486,542097,62211,301099,275798,379941,296343,830856,797730,385037,839038,86306,708119,282801,494229,731858,783074,407616,759874,890659,1021247,245934,606861,914752,692021,265838,635808,114320,104251,754261,260128,485540) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 310641 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 310641 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000640s ]