SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 114476 LIMIT 1 [ RunTime:0.001934s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 114476 [ RunTime:0.004220s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (174211,35438,422864,344479,523233,559690,99626,127808,506761,723259,699824,357764,396132,173661,722503,611249,539639,988131,1026638,350720,233502,271962,1019258,710669,262041,711553,212493,646623,418457,317486,996852,851947,646476,535363,949676,337320,585686,65512,778361,962110,781970,414280,71673,720059,182140,594461,704116,534324,589348,314342,341593,148438,1023842,138228,264000,726425,791723,790100,559097,105500) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003829s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 114476 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000464s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 114476 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002172s ]