SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002178s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017004 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017004 [ RunTime:0.002357s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (411389,1021380,872230,1016795,732741,653126,831307,606757,959632,346910,89297,671132,685114,236026,730242,219825,754642,260272,248537,907917,940112,452182,491331,214467,599874,207181,262313,111294,501293,208918,1000047,443684,774586,239236,244375,161431,605287,282096,136102,555750,1045761,22004,894274,693279,772865,202422,855041,1011573,231294,532758,733252,196714,234328,679358,162040,712421,487591,784034,551778,179041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001318s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]