SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020186 LIMIT 1 [ RunTime:0.000551s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020186 [ RunTime:0.002950s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (846185,609026,689379,611566,313004,522752,273519,310763,410833,572814,762407,183742,172225,125205,344108,368904,947468,573555,828351,41369,398213,662417,122695,701038,169563,291088,956810,861898,19468,296752,412679,992513,4145,598173,542656,472383,427699,446861,441214,673788,726512,184636,50210,961949,64141,552643,641088,878293,73073,497751,482446,967813,679371,628092,24120,420536,23661,831179,238930,971510) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020186 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020186 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]