SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555082 LIMIT 1 [ RunTime:0.000292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555082 [ RunTime:0.002947s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (257411,12402,683595,825971,298996,544338,597777,201644,686964,474712,547489,698739,248940,672551,403587,123425,785450,1004107,437712,434646,932963,575350,495717,512890,95174,593376,869535,224231,37840,108799,121308,1021540,249413,306994,889988,270697,833163,409213,1004406,982712,198326,286565,332323,219617,861494,450633,9295,530759,1003967,300327,155732,629623,883519,266186,588223,202214,369054,776975,799662,1000988) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555082 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555082 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003327s ]