SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539104 LIMIT 1 [ RunTime:0.000285s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539104 [ RunTime:0.002056s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (253935,332937,483225,521129,667853,168306,371652,63240,177200,903817,484883,136358,339663,566905,761290,304227,425554,465286,854882,464775,221374,710323,324920,926911,901419,746139,40294,290680,551320,841059,603552,241015,65349,590357,727687,558390,452384,402202,776062,23863,84762,297791,775528,918217,940506,892244,523849,844577,405298,94788,54709,338961,619975,539801,215952,608331,182069,411312,297029,490025) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001096s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000405s ]