SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001694s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040892 LIMIT 1 [ RunTime:0.001021s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040892 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (358343,203432,519932,342160,980293,411038,145407,906676,412696,728993,345750,210230,22005,1005448,18229,994820,211729,445722,968482,618647,755222,1048738,591835,998976,806358,900787,869295,886845,443072,190009,768237,964027,23081,580677,618742,970458,993149,847263,459203,604823,939286,610057,581341,879153,125925,314120,813286,132012,493980,169646,624879,83191,597714,994195,243158,499365,704409,605400,738236,460231) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009779s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000569s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001619s ]