SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 280409 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 280409 [ RunTime:0.006343s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (851474,801206,723746,418735,214102,199596,985307,693852,405880,381417,324636,548714,18562,456614,239570,119989,532702,288163,668891,133789,792790,457735,204567,346228,1018290,837589,55975,322427,974101,579369,313243,626729,755986,898055,472745,1001793,694872,574128,444249,296948,357770,431164,425668,219320,269128,47426,495584,175932,932488,30996,629850,200043,193321,354574,716123,32998,716534,223859,990090,477996) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001799s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 280409 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 280409 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000686s ]