SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001416s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 297043 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 297043 [ RunTime:0.003521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503510,718798,494573,880802,420263,798011,980006,256010,202604,338697,881574,117350,346546,220168,523702,141033,1009031,1028815,349862,907643,594676,638073,841272,590453,1016266,773093,829414,283874,978756,226049,1046224,395478,494804,560545,611678,758333,411927,912006,632769,56902,636276,46460,768518,317483,933634,1008071,448290,311906,182584,143687,853434,140256,195607,943203,109759,1009241,81621,375467,615216,458265) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 297043 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000551s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 297043 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]