SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002998s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 22860 LIMIT 1 [ RunTime:0.002432s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 22860 [ RunTime:0.008088s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (310038,651680,257171,566606,758535,801033,524411,465980,445397,80741,454366,1031887,974331,923843,257131,674313,246290,488578,109901,158275,244333,137752,817590,537776,978495,988695,517105,873325,16120,788974,769739,931077,82917,201741,874416,620716,992447,248279,268208,153644,668608,396715,10412,280319,488916,941387,874412,92186,858351,50525,520988,499649,632630,208394,45347,423092,771792,259208,312829) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001129s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 22860 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000404s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 22860 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]