SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 578876 LIMIT 1 [ RunTime:0.000311s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 578876 [ RunTime:0.001861s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (260597,1034433,587233,50547,400488,289816,742158,177973,778321,307025,277950,612319,826329,160873,921524,563244,596715,200032,297955,157250,977305,30112,676709,351767,429251,789734,63267,430568,428782,360553,16193,713445,181586,156824,510949,470462,566966,1004017,120872,413628,459449,25799,980315,424096,721304,45946,509122,853602,443939,628152,472946,810833,998545,125211,957713,486172,451280,277236,195099,160919) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 578876 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000501s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 578876 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]