SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312807 LIMIT 1 [ RunTime:0.000485s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312807 [ RunTime:0.003582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (12743,941786,747471,1001477,102975,791505,710664,99413,250586,370076,186765,215163,350172,515256,701960,1011802,38534,444769,903070,136173,375897,551042,257970,812650,9826,344134,398772,435340,989988,280798,925184,1021175,690830,799580,148504,294007,858774,634143,54081,3335,131994,670324,398148,23447,297837,205866,502332,712711,624990,125516,342455,807038,120072,794227,470377,73248,784324,851301,744626,888832) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312807 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000408s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312807 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]