SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56203 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56203 [ RunTime:0.004714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (580526,676465,759701,668919,1020462,402849,568282,185496,916406,794134,43519,378806,945273,11673,431041,405105,345367,920219,852859,449161,518260,149796,933713,120464,779515,707370,160648,393709,556235,1042055,215297,541887,220611,24660,683845,20252,445883,785303,805202,860021,729034,992463,265441,932183,396015,504073,89166,371814,969011,852977,264968,237636,343570,1018359,163820,63600,779466,827799,620833,866350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56203 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56203 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001660s ]