SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001319s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 211808 LIMIT 1 [ RunTime:0.000402s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 211808 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (444570,357356,611126,160716,786347,818218,927285,62443,581182,827918,681936,1042180,539170,413624,698150,607190,35525,300642,1047960,27531,416124,114621,706365,1032738,65188,519650,992418,598802,278039,497558,984049,698244,678210,1004534,204082,933926,1045133,411552,730643,166578,489944,464176,346561,422617,396713,796055,591814,358873,591912,969981,62494,847083,331126,730322,609285,237769,81013,96355,861008,492342) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 211808 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000634s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 211808 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000496s ]