SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001124s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 386313 LIMIT 1 [ RunTime:0.000278s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 386313 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408735,354454,536207,208083,162540,345568,923449,203060,634157,135313,717903,163471,121651,858545,988557,802898,769384,14013,384856,85539,631160,873066,602415,1012250,351486,893989,87639,1047703,273571,620936,740146,340329,1040064,733940,863496,227008,666311,530305,561126,104189,477585,315347,377268,28023,937877,28633,953554,533444,646081,200186,781283,979453,597693,528329,52569,563477,509498,616937,758014,410846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 386313 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000345s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 386313 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]