SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001515s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801298 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801298 [ RunTime:0.002582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104161,432488,340748,821724,453847,526793,609798,18343,768295,138312,857729,39209,872570,84300,295405,93920,338264,910765,867589,364782,163047,368674,88777,165757,670861,708263,648908,180389,816132,1044408,440304,379018,437299,671300,874321,595514,98874,758044,406513,960378,349258,691910,304261,295876,911319,556130,628867,911660,628122,82159,48533,913144,208128,728038,652512,768040,503899,869972,710927,225221) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001102s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801298 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801298 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001833s ]