SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 520084 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 520084 [ RunTime:0.001719s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (226639,1025667,644201,965817,52591,721870,126887,888460,614846,57321,637873,830754,532765,49248,74043,898290,391341,270570,385329,278005,494727,612369,902546,419883,1048701,901530,689292,368413,830483,454254,189966,678051,547762,295662,971031,715781,1033328,212938,762507,706700,594242,496814,409763,289879,97891,540250,866306,56286,572615,33587,840485,347028,263334,695993,1026924,278832,246146,42514,94288,549994) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001254s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 520084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 520084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000435s ]