SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002607 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002607 [ RunTime:0.001814s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (323138,268240,952585,494223,44995,295617,72105,655005,176412,103416,1010214,352789,910124,216130,295023,39225,756376,922941,149313,165009,680594,641178,31663,1033852,609288,584949,630556,955101,662782,744924,138609,59794,6718,273348,232728,9290,248516,744803,255301,1021752,988676,441700,213278,54984,798874,53808,253377,888701,105763,1006106,471478,288003,701104,545900,881305,865679,427579,1042556,824717,79658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002607 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000332s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002607 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000924s ]