SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447524 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447524 [ RunTime:0.002135s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (75718,957154,102940,283570,32166,41350,434118,881818,114867,957826,750486,571654,977682,628849,483474,655835,707606,205331,609646,987484,600231,415416,50454,564469,478736,495738,294825,1430,870293,583770,1005640,611995,730160,359136,594552,68649,532443,863222,611508,297944,296906,626802,503001,644387,196315,757581,364822,203363,953566,739705,407796,817289,672239,913657,414959,308982,370234,418263,57281,211127) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001082s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447524 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000373s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447524 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]