SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1012184 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1012184 [ RunTime:0.002435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (600808,522734,526684,154231,145800,54440,200450,548773,219760,608067,316733,203331,112243,879238,453799,469423,1044262,303131,696767,291239,594360,850968,392747,656149,293097,558365,488716,950270,661194,1048719,747509,186523,999316,182231,28741,78107,979166,925844,742801,549920,485228,497625,532354,957118,969336,233776,425398,571913,63881,895700,324412,144944,341372,953534,962262,755022,295428,518251,452037,774485) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001230s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1012184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1012184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000475s ]