SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42936 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42936 [ RunTime:0.001714s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (192546,811680,670012,887921,936507,410784,507921,485464,588860,667550,640240,993516,401704,250374,236048,345618,261142,1047922,283112,816764,438793,458145,867416,145706,424966,584751,415726,325738,344641,854119,789048,117837,150546,675670,225624,133164,179364,719626,599930,103793,823146,125014,682878,764973,447209,966458,128795,1039117,789041,167298,993091,103071,720769,314214,1046208,778783,63554,10880,228353,981454) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001008s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42936 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42936 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]