SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 230413 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 230413 [ RunTime:0.002884s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (369538,55716,22065,24553,528858,945196,355636,670082,244576,952430,570521,293210,622008,183068,332637,993624,414337,390889,49747,606583,262920,513648,39741,1020554,949364,567341,907318,194027,1013483,147341,47929,928506,232924,315238,547792,164337,971312,376880,96116,251518,1016954,799461,478828,1029789,33849,869742,725599,674737,75394,906961,708041,474647,112546,181166,695187,201752,423355,527211,750093,30759) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 230413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 230413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000738s ]