SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 710582 LIMIT 1 [ RunTime:0.001404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 710582 [ RunTime:0.004162s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506027,76811,355819,70779,817256,150289,736811,131148,111026,213524,918809,571067,619240,107684,475314,260076,705788,618660,973423,563808,799655,371030,152857,952834,1019567,992867,520697,624142,1005168,13294,514876,716274,418042,477311,605792,812382,302049,65454,589769,56156,61982,378011,1008541,617729,250160,134969,482777,943400,766458,930868,497192,783085,224239,1034369,527102,299309,556350,365289,99226,530595) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 710582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000535s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 710582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]