SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416910 LIMIT 1 [ RunTime:0.000293s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416910 [ RunTime:0.002385s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (971541,157418,193246,673312,560182,650277,471099,194178,643230,629975,805448,644287,1004788,5333,935864,481810,630888,896272,757909,988123,1035570,943033,835262,373303,196477,429138,100563,730085,596217,8670,261142,189459,277754,229929,524557,247499,362793,20403,714651,981868,2376,755768,265226,968950,165002,47851,794530,362415,384825,550646,169318,236709,771597,993989,722063,74946,76034,237861,578310,427376) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416910 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.006038s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416910 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002940s ]