SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 410201 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 410201 [ RunTime:0.002005s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (299702,146785,215307,508217,230321,105702,604865,992546,846742,905741,153601,969952,352099,602858,507311,880455,845920,231606,263574,1045972,505586,339854,393075,398787,751378,815300,355171,1008245,169340,973298,38942,916401,927978,511762,388146,317072,225469,320430,321071,436788,263453,741656,167832,304354,255794,644101,134648,492560,100256,746125,731122,451273,391940,717303,554757,1028065,491007,369726,916408,478085) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001057s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 410201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 410201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000603s ]