SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414249 LIMIT 1 [ RunTime:0.000366s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414249 [ RunTime:0.001941s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (430267,1021023,12793,608563,111836,613048,252101,1026500,226092,800550,278492,194765,541988,358470,84263,244444,865753,51390,1022052,807010,194588,531092,203594,277639,149900,396350,169586,392202,465058,834439,807414,873152,268199,690373,897214,911139,188876,819650,638328,773425,1042254,996675,375190,186641,148811,882781,264975,34220,69066,295350,247984,72598,1007675,952747,1012443,117887,239043,126356,555556,465902) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000922s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414249 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414249 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000546s ]