SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001421s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447566 LIMIT 1 [ RunTime:0.000512s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447566 [ RunTime:0.003996s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696658,559532,776716,359206,935974,647944,297419,990132,268099,339664,118640,883997,396737,773505,897158,516884,699065,309763,229603,269058,870681,46721,737068,233176,353465,913712,991891,811455,368425,623905,145539,535061,55368,277312,25095,392851,810679,599156,736474,282530,672685,515593,812851,248766,708618,198710,194219,5991,468069,1019534,372055,86028,394283,727185,393601,857192,193689,649874,878054,912304) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447566 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447566 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000602s ]