SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001309s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 499283 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 499283 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521412,987413,387427,908378,307207,265968,321081,708614,386952,268326,312666,3028,837059,216415,180898,969709,640460,876294,622477,841909,488682,706195,176036,464088,628110,432102,795839,527125,182146,84393,210128,490834,39349,582427,676443,444316,906564,20916,81168,826888,714515,1003903,36164,904756,911192,983382,1001956,132258,362218,238179,946647,691204,549419,109955,62495,528902,255454,909413,970388,853252) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 499283 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000393s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 499283 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]