SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 308210 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 308210 [ RunTime:0.003076s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (719081,133026,202897,443317,363010,98818,776643,615229,56695,74934,956461,287090,236040,462486,138767,971707,722104,239287,1038526,821317,72334,298013,121728,689268,234066,499462,202524,419995,316481,841436,867947,122316,282058,86961,824930,266284,854863,1019195,461933,711888,81176,376934,222760,318453,674865,186315,298046,304810,705287,347665,92541,645736,123387,13555,799273,916235,917246,216334,329657,821831) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 308210 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 308210 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001090s ]