SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 805309 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 805309 [ RunTime:0.004124s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (593580,1046572,655727,465266,999489,556558,135778,498757,573592,596316,960853,939808,321685,312522,300446,570663,654379,87581,753293,959109,758988,554210,983398,748733,476265,899592,820634,292410,418591,657964,13167,896791,480639,577939,422784,918027,772029,925253,444683,1040421,202162,98448,912930,921478,512136,931842,829318,164630,887243,949459,180574,772105,342879,107589,75129,390082,153463,1012633,36046,791029) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001242s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 805309 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 805309 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]