SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002329s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41281 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41281 [ RunTime:0.001574s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (801718,45312,227574,905966,874666,650798,898609,101470,568140,309859,741227,593271,549480,654983,211023,762688,958764,946389,627404,452572,182433,387673,558394,1046509,858670,642727,362631,732120,833250,810787,732927,311152,26187,1017350,704698,696090,837652,265259,220068,480258,166543,925306,139376,279273,752259,432205,533574,865787,863017,101517,420108,37335,246148,739154,200295,522107,333955,144624,349689,962635) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41281 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41281 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]