SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28668 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28668 [ RunTime:0.001831s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (392773,909123,462995,244904,409535,282368,44994,768962,321562,50067,360695,817751,959883,39184,886902,162032,548491,936048,953586,851033,131744,635830,268656,940347,515852,1043809,813322,914487,899414,434681,893906,877927,862925,536197,990254,504626,1015845,746564,569133,766472,965789,889765,387136,237551,426153,875130,650385,373983,826073,875645,1042742,564565,430501,273713,434766,622269,91805,704421,223512,637615) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001540s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28668 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28668 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000488s ]