SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410553 LIMIT 1 [ RunTime:0.000437s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410553 [ RunTime:0.001851s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (569575,994597,711067,145519,93982,979537,984902,7071,79325,368298,922390,478972,223985,58151,887858,370400,129780,94777,245451,392499,992511,31002,960731,965207,944224,933737,465177,872119,1021954,775553,242672,236926,187771,573832,695354,372175,72884,778679,445862,805123,330255,714414,994405,867539,754647,290710,289586,339235,914306,684582,803933,1034605,101050,530667,451578,996028,746234,674294,763154,251079) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002647s ]