SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 116897 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 116897 [ RunTime:0.001668s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (738072,714383,722498,942992,430404,1024678,622877,193330,437984,20628,276073,112749,98682,198371,229093,503148,143289,42492,740253,122974,1029437,580454,17606,258201,780187,54267,634652,70682,327292,421105,123558,223546,977765,480895,940180,967815,214653,697952,157158,320564,189772,662941,803870,789833,130638,599221,361481,140342,403934,92210,544507,720290,676751,453526,418900,618601,790043,584737,381021,10783) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001032s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 116897 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 116897 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]