SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001849s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281584 LIMIT 1 [ RunTime:0.000497s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281584 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (173358,105584,837871,555219,568697,570013,662028,382536,603963,881678,451590,331013,106384,347168,29378,982632,550992,108963,512013,694248,1032480,300845,26535,729822,196887,190242,812187,606894,998838,430566,648116,800621,644139,617713,968854,604961,295339,233438,976750,418927,1023999,156451,108740,593016,61383,440128,774603,801163,873575,533737,363414,322252,128485,894706,4782,690450,875929,411557,419701,674698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]