SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575411 LIMIT 1 [ RunTime:0.001574s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575411 [ RunTime:0.002473s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (838438,364996,125093,1041885,370583,290831,698196,22060,662012,345718,508801,805356,168846,548553,796279,911268,294197,247700,691066,227923,966096,857520,871722,70216,410699,627314,199095,504435,747975,87172,596610,385784,18084,1027896,195997,288758,714655,265380,25712,93288,96885,119856,432179,718607,45967,1040154,275063,447970,27087,172379,944758,103061,252176,355042,387930,71085,929929,103162,455040,297980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002112s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575411 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575411 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003667s ]