SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 541406 LIMIT 1 [ RunTime:0.000380s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 541406 [ RunTime:0.003438s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (364226,200133,673691,881562,528784,85642,559754,899858,566206,187011,278638,648945,129278,592343,812392,964508,533639,652817,770269,517129,477287,49142,873154,82813,206726,400714,551564,45864,704742,303275,20387,861924,193467,629339,967836,414904,128810,720602,921212,954476,534735,448400,992377,494430,377037,1047600,194459,360802,981466,124792,659555,449176,534131,791808,408342,311036,890953,921851,623056,802067) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 541406 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 541406 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]