SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410956 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410956 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (223360,884061,158455,5813,712051,299190,965367,847607,153949,98995,775057,504847,1007907,511276,486020,60073,969861,342167,216292,4605,895350,975275,996892,755720,738158,25964,408536,77064,984352,378271,585915,503813,388452,693900,53791,75598,332939,989303,922486,833390,784031,546569,564121,334665,218029,601652,91570,77582,415261,770986,882105,814691,560500,637124,447490,443773,385117,332720,697193,4212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000935s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410956 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000324s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410956 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000469s ]