SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101981 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101981 [ RunTime:0.001795s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (748908,10713,478884,429685,121096,795098,481386,816554,694040,364243,193090,815103,470813,254521,425817,899149,210253,370057,1004534,446082,137815,422759,646061,528874,147666,183631,579347,245869,301392,909962,389858,559920,942579,300172,370591,924136,548167,752816,932051,1015488,957846,330059,287470,246876,942767,23512,911500,179875,1041449,131448,840097,575797,282861,436234,428736,109593,955948,303920,214894,956405) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001156s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000420s ]