SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 240717 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 240717 [ RunTime:0.002698s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (200018,497369,358850,968597,643673,948672,34432,1014984,57113,153561,73955,50830,895414,739202,596241,229368,959432,879079,581528,940736,200910,973804,435251,122944,992484,185342,571987,417753,519754,527783,549766,268504,482737,633945,801773,907878,736411,496319,633109,552306,944421,1025463,324561,778117,609055,149404,527278,965335,320465,845509,412129,244119,937692,196465,637620,51903,699203,728831,310642,167826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001473s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 240717 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000476s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 240717 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]