SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002035s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 279180 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 279180 [ RunTime:0.002442s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (826437,479540,508760,475391,106359,903929,778878,505847,101166,722989,126513,912999,766203,927930,497569,62677,170815,573397,248118,403653,755517,365758,877827,418943,747390,702180,966217,745369,733937,809112,709471,1025130,34547,648396,340711,812580,343568,794005,642001,410271,124462,921871,70950,198704,393595,10385,48028,288364,334002,693249,677551,521054,609622,99167,278644,286792,367765,144480,717390,304878) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004927s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 279180 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002292s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 279180 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000559s ]