SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 4336 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 4336 [ RunTime:0.001641s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (591434,418133,867178,712966,872439,22135,615920,708962,463805,16629,58927,362399,52860,652358,40905,867364,384226,677919,134008,492435,1015567,248698,647073,467926,649447,398196,107421,822387,146558,14101,439062,857386,933265,100966,475819,382812,330055,450264,572461,648734,980359,80749,778140,928256,474083,255241,710223,412728,797535,277030,38184,360654,418081,225526,873092,785093,906915,561267,582673,714778) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001062s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 4336 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000436s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 4336 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001138s ]