SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002605s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 96202 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 96202 [ RunTime:0.002383s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (765370,748860,658983,264930,126124,610661,1009465,68037,942324,70681,353535,575653,440235,230921,26874,404729,200203,257845,412068,260536,254316,360387,141162,177968,745082,982653,27257,801079,881247,925921,811821,906025,844636,322651,380466,526028,34246,607191,767309,547313,996239,319376,1034080,825456,961557,1014278,750538,392891,431152,630553,729853,282047,699242,606246,40906,691429,535633,411735,46124,554515) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 96202 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 96202 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]