SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1002412 LIMIT 1 [ RunTime:0.000412s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1002412 [ RunTime:0.002076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534912,773823,367640,711771,631291,196371,277009,713036,723480,456267,262083,975083,891847,73850,329537,275088,487644,987695,287371,881761,848494,821373,319183,746881,950825,86217,418302,861439,885907,235871,880587,796244,895662,166058,542447,282966,739769,584142,48485,78741,485216,894516,954159,716498,864442,573055,554085,411917,655931,55660,200127,126050,189944,288001,22490,698698,669200,515232,53200,161853) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1002412 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1002412 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]