SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514910 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514910 [ RunTime:0.001552s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (598415,70420,859591,286118,359916,750565,827911,287669,500476,219255,307761,148951,498929,435035,946845,334363,421775,317135,730558,672677,274451,667049,120950,930136,1017990,895665,267717,238895,401299,735704,132491,171041,725084,403312,488970,832165,38193,663333,933825,533069,469102,630451,859681,528425,377612,248056,368917,991198,788386,534769,568301,137465,930042,832382,956825,180817,253792,758721,1023706,680329) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000375s ]