SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001161s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542809 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542809 [ RunTime:0.001624s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (393585,955448,907709,229385,833046,431,18255,755492,18619,778923,220947,716503,600769,856560,203911,761510,100668,574934,190615,96082,908682,448525,682549,916443,225414,189527,1037864,286258,11899,842568,747717,651054,227990,111164,752010,174156,221488,87064,334616,775453,639801,587907,635100,42060,523860,445711,881692,932369,539837,275286,109594,837377,805391,962523,101644,42051,967893,478625,910932,613178) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542809 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542809 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000470s ]