SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 305494 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 305494 [ RunTime:0.001715s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (503411,721959,853778,78824,395455,106415,758651,215631,385093,425297,533340,548870,40329,812098,36939,1022041,919248,964650,577788,907080,1028386,768153,286144,671889,861665,62549,672710,976126,52778,299505,488136,722612,793516,256616,333887,798587,204256,37353,691070,528868,663747,347851,408075,26802,291709,115975,741836,499797,268498,646001,323572,834690,827480,695506,123605,248169,1017841,335750,718819,221510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001024s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 305494 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 305494 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000547s ]