SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001458s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509150 LIMIT 1 [ RunTime:0.000436s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509150 [ RunTime:0.002035s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015231,296942,405160,779618,451869,765815,228074,907811,124569,643168,608347,892471,4638,617862,917397,1015336,14674,797416,632441,300343,329443,378867,109366,144432,83316,742123,351914,308913,355728,482359,969602,272832,666094,315043,19698,673795,85096,882008,811724,406654,634032,705607,665034,234621,223670,611949,387628,333736,742372,676218,239176,558452,646048,455333,700592,186405,524545,669590,961270,488865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509150 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000516s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509150 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000498s ]