SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481071 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481071 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (897198,795115,36671,131634,513672,453693,554342,230601,921176,120496,506263,219238,655510,434552,942606,403289,1040451,623140,611775,661999,629646,486859,585959,462240,276252,395156,497829,889215,73644,823428,368846,281287,653,553520,314949,808952,96216,299163,667886,793010,116134,958654,444078,941152,909019,1026461,444323,775624,184813,919484,484919,984866,919626,1002628,52592,945930,12506,613802,561364,612234) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000347s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004869s ]