SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001316s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 466628 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 466628 [ RunTime:0.002146s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (585681,80922,257533,207449,864359,266961,156534,194128,221031,681056,369992,991791,1000302,263325,229305,729657,650227,335186,115702,681819,289743,44965,31671,827568,335593,612750,544261,1001785,117871,9914,479162,952958,296416,625057,800840,752411,122766,139027,996943,223584,369942,190818,362153,309650,986735,561548,869931,194857,122125,443607,380057,163490,420765,948962,368218,191549,1043108,528678,23741,151870) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 466628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 466628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]