SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 53114 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 53114 [ RunTime:0.002039s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (452456,714710,500494,838971,69457,838565,751961,760369,8476,369195,720635,857944,652410,111484,862886,975112,1020553,642743,551008,993064,577643,53628,265525,646889,738951,708253,458016,886321,577193,286401,48968,327564,453031,629307,297108,996378,831659,842713,138049,610585,757373,84889,792168,107078,503367,451278,678607,655747,1032374,331972,325896,512749,10314,19160,9990,178132,520176,986519,784457,579773) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000934s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 53114 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000579s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 53114 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000445s ]