SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001233s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 71448 LIMIT 1 [ RunTime:0.000338s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 71448 [ RunTime:0.001963s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (454441,174062,481193,715605,115540,162511,277256,333442,9119,44652,685820,422010,868487,482790,791653,653781,442473,241234,12235,711573,164194,318312,1029757,337626,142300,140668,617121,1007348,585086,420759,529194,46594,275218,525069,546555,586800,313370,1011820,749601,386950,151823,151758,412992,911227,1010116,109209,421799,738152,647045,133369,580909,264123,85937,156190,566891,754941,759322,171309,919071,294957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001065s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 71448 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 71448 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]