SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499681 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499681 [ RunTime:0.002613s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (534146,1006404,911931,788157,819577,1011325,429421,897261,649419,90924,76592,763450,9123,204168,890600,1030246,159950,610974,277018,267297,179849,925095,129855,911613,60331,939379,701628,355214,46932,393949,1001956,503885,500979,271543,573670,211199,495685,387865,987682,762404,252358,347772,227487,457374,1000589,850242,1000958,125324,887454,836514,29253,806923,346246,298536,956684,244129,770471,483409,31880,572986) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001770s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003051s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000690s ]