SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 681018 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 681018 [ RunTime:0.002171s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (68786,974638,990125,56404,168242,602075,621170,384733,98691,723570,200760,460035,471818,264496,34545,544881,512989,10293,503490,31489,291703,488305,763104,315344,116849,189624,249885,573441,627946,804699,940605,801729,463909,423177,973207,378480,1000748,967059,505925,948084,519493,340897,54657,470001,473377,723670,2232,636986,410079,2183,338459,667324,61480,370380,529837,668048,322283,256273,402928,80455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001499s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 681018 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000487s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 681018 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000739s ]