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` = 804698 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 804698 [ RunTime:0.002791s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (124968,106193,107368,871412,687882,665171,897197,1038505,644743,667092,60318,362309,942207,22995,791240,404968,646096,385253,209515,236897,461744,1015294,843950,764822,430260,920660,218671,458653,864983,348501,906750,1018725,607137,361973,440882,507085,39928,81249,739423,947640,354048,153918,888763,353981,640800,335060,312819,556683,270210,862569,34617,857648,618137,293560,202262,874170,788505,225456,501003,671434) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001244s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 804698 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000391s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 804698 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]